Plot AggCo (all variables) with RPKM
maybe with limits.
SELECT ID,"Percent mCpG (mRNA)","Percent mCpG (CDS)","Percent mCpG (Intron)",
swissprot, "Sum mRNA", Mgo
FROM [sr320@washington.edu].[table_AggCo Oyster Bisulfite mRNA and CDS.tab]
LEft JOIN [sr320@washington.edu].[Zhang_etal_SuppTable14]
ON [sr320@washington.edu].[table_AggCo Oyster Bisulfite mRNA and CDS.tab].ID=[sr320@washington.edu].[Zhang_etal_SuppTable14].GeneID
WHere Mgo ]]>
0
and "Sum mRNA"
]]>
50
--
SELECT ID,"Ratio mCDS/mIntron","Percent mCpG (mRNA)","Percent mCpG (CDS)","Percent mCpG (Intron)",
swissprot, "Sum mRNA", Mgo
FROM [sr320@washington.edu].[table_AggCo Oyster Bisulfite mRNA and CDS.tab]
LEft JOIN [sr320@washington.edu].[Zhang_etal_SuppTable14]
ON [sr320@washington.edu].[table_AggCo Oyster Bisulfite mRNA and CDS.tab].ID=[sr320@washington.edu].[Zhang_etal_SuppTable14].GeneID
WHere Mgo ]]
]]>
1
and "Sum mRNA" ]]
]]>
50
104.txt
SELECT ID,"Ratio mCDS/mIntron",CDScount,"Percent mCpG (mRNA)","Percent mCpG (CDS)","Percent mCpG (Intron)",
swissprot, "Sum mRNA", Mgo
FROM [sr320@washington.edu].[table_AggCo Oyster Bisulfite mRNA and CDS.tab]
LEft JOIN [sr320@washington.edu].[Zhang_etal_SuppTable14]
ON [sr320@washington.edu].[table_AggCo Oyster Bisulfite mRNA and CDS.tab].ID=[sr320@washington.edu].[Zhang_etal_SuppTable14].GeneID
WHere "Sum mRNA" ]]
]]>
50
105.txt
EXCEL
